AddSparkline(SheetCellRange[],CellRange[],SparklineType,ExcelSparklineSetting) Method

In This Topic

Adds the sparkline.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function AddSparkline( _
   ByVal data() As SheetCellRange, _
   ByVal location() As CellRange, _
   ByVal type As SparklineType, _
   ByVal setting As ExcelSparklineSetting _
) As ExcelSparklineGroup

'Usage
 
Dim instance As SheetView
Dim data() As SheetCellRange
Dim location() As CellRange
Dim type As SparklineType
Dim setting As ExcelSparklineSetting
Dim value As ExcelSparklineGroup
 
value = instance.AddSparkline(data, location, type, setting)

public ExcelSparklineGroup AddSparkline( 
   SheetCellRange[] data,
   CellRange[] location,
   SparklineType type,
   ExcelSparklineSetting setting
)

Parameters

data: The data.
location: The location.
type: The type.
setting: The setting.

Remarks

The data for the sparkline is limited to one column or row of values.

Example

This example creates a sparkline in a cell.

Visual Basic

Reference

SheetView Class
SheetView Members
Overload List

Product Support Forum | Print this page